SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
 CREATE VIEW [dbo].[AppointmentDoctor] AS 
 SELECT [Username] ,
        [Password] ,
        [Title] ,
        [Firstname] ,
        [Lastname] ,
        [DisplayName] ,
        [CellPhone] ,
        [Email] ,
        [Avatar] ,
        [Note] ,
        [UserGroupId] ,
        [ServicesId] ,
        [IsFemale] ,
        [IsDisabled] ,
        [CreateUser] ,
        [CreateDate] ,
        [UpdateUser] ,
        [UpdateDate]
 FROM   AppointmentSystem.dbo.Users 
GO
